Tenant Email Notification System
Migrating from Manual Outlook Lists to a HubSpot CRM
Project Overview
A commercial property management office previously relied on a fully manual email workflow: contacts were individually entered into Outlook folders based on tenant self-submitted forms, with no automated way to update, remove, or segment contacts. This project replaced that system end-to-end with a HubSpot CRM, delivering a dynamic, compliant, and analytics-ready email notification platform.
The Problem
- Static contact lists required constant manual upkeep
- No automated bounce-back removal
- Opt-outs required emailing staff directly
- General and sensitive notifications shared the same list
- No open/click tracking or delivery analytics
The Solution
- HubSpot CRM with dynamic, self-updating contact lists
- Custom email sign-up form with automatic contact creation
- Resubmission auto-updates existing contacts
- Personalization tokens (e.g., tenant name in greeting)
- Built-in unsubscribe, mobile-optimized templates
The Challenge: A Broken Manual System
Managing tenant communications for a commercial property campus should be straightforward β but the legacy process created significant operational overhead and compliance risk.
How it worked before:
- A tenant submitted a paper or digital form with their contact information
- Staff manually typed each contact into a named Outlook folder (one per building)
- Contacts stayed in that folder indefinitely unless manually moved
- Bounce-backs required staff to notice and remove addresses by hand
- Opt-out requests arrived via individual emails to the office
This approach did not scale, produced stale lists, and offered no visibility into whether emails were actually being read.
The Solution: HubSpot CRM Pipeline
Data Migration
Existing Outlook contacts exported to .xls and bulk-imported into HubSpot, preserving all prior tenant records.
Sign-up Form
A HubSpot-hosted form published via QR code and short link (Bitly) captures new subscribers automatically.
Dynamic Lists
Contacts are searchable and filterable. Form submissions auto-create or auto-update records β no manual entry.
Email Campaigns
One-time blasts or automated sequences with personalization tokens, branded templates, and compliance-ready unsubscribe links.
Analytics
Delivery, open rate, and click-through rate tracked per campaign β closing the loop on what actually reaches tenants.
Key Feature Highlights
Dynamic Contact Management HubSpotβs list engine means contacts are always current. Resubmitting the sign-up form automatically updates an existing record rather than creating a duplicate β solving the stale-data problem that plagued Outlook folders.
Compliant Opt-Out Every email includes a one-click unsubscribe footer, meeting CAN-SPAM requirements without requiring tenants to contact the office.
Personalization Tokens Email greetings auto-populate with the tenantβs name, making mass communications feel more personal and increasing engagement.
Delivery Analytics The HubSpot dashboard tracks delivery status, open rates, and click-through rates per campaign, giving the team concrete feedback on communication effectiveness.
Campus-Wide Rollout The launch used a printed flyer with QR code, a short link for digital sharing, and an introductory email to the existing list β all inviting tenants to opt in to the new system.
Outcomes & Impact
Time Saved
Eliminated manual contact entry and bounce-back monitoring β routine list maintenance now requires no staff intervention.
Better Reach
The QR-code and short-link sign-up flow makes it easy to grow the list beyond the original tenant base to campus employees and visitors.
Visibility
For the first time, the team can see open rates, click rates, and delivery stats β enabling data-driven improvements to future campaigns.
Compliance
Built-in unsubscribe links and opt-in forms align the system with email marketing best practices and CAN-SPAM requirements.
Tools & Technologies
| Tool | Role |
|---|---|
| HubSpot | CRM, contact management, email builder, analytics |
| Bitly | URL shortening for printed materials and QR codes |
| Microsoft Excel | Data export / migration from Outlook |
| Outlook | Legacy system (replaced) |
This system was built for a commercial property management office to modernize campus-wide tenant communications. The project covers CRM setup, contact migration, form creation, email template design, and campaign launch strategy.